package com.usian.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.usian.pojo.Product;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ProductMapper extends BaseMapper<Product> {
    List<Product> findAll(Product product);
@Select("select p.*,s.name sname from product p join supply s on p.sid=s.id where p.id=#{id}")
    Product findByid(Integer id);
}
